UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VtvfTfOA5OnUDMibegbin/5q9XEAj+HINl6VcZc51S4='
WHERE
key_id = 'd06ac4e70875219d4fe3fa13e3fb93601ceb89e0379428e8a9e6908dd64ea73b'
AND (
token = 'VtvfTfOA5OnUDMibegbin/5q9XEAj+HINl6VcZc51S4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)