UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pDyzr7tvLY7L1W7DvgQiNT7ISz+A+nGRR1j8UR0sid4='
WHERE
key_id = 'c9aed2e499098af814e9c2753d9ab94a20e28553ab774a0b2d498ea083b8b0e6'
AND (
token = 'pDyzr7tvLY7L1W7DvgQiNT7ISz+A+nGRR1j8UR0sid4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)