UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pX5Kt/JSfffIrUt4ikZiOSZMpdrX8Hlh3YdZmxL/bBI='
WHERE
key_id = 'b6da99b75e6ab63236fd2d2c237f0b3521e35f574fd16dfe3b29a45a2f3b0fd8'
AND (
token = 'pX5Kt/JSfffIrUt4ikZiOSZMpdrX8Hlh3YdZmxL/bBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)