UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1TEEwys/9nqqsy432heOeN3OJu9vfACBcb42zUjK1Sk='
WHERE
key_id = 'bc75c7ebcb9ab85a00e224581f3293a317569ef35565d4f8b22d498be04a5159'
AND (
token = '1TEEwys/9nqqsy432heOeN3OJu9vfACBcb42zUjK1Sk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)