UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'APCvvkjk6aokOfE8xTjYQDGtU0TZUfaH90tF99T2cYA='
WHERE
key_id = '2253c0dbba0b7a69805224d7cfda96e1c752a35d5c51f897e8e7139aefccee4d'
AND (
token = 'APCvvkjk6aokOfE8xTjYQDGtU0TZUfaH90tF99T2cYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)