UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2oxjyD/JNgwOxjZ/ctCo96Pz8xwqCjJNVKIh4PtF4V4='
WHERE
key_id = 'c246803a07f2b05fa5ac37e47421fff73f81ca88a79bdb464b99667fc016081a'
AND (
token = '2oxjyD/JNgwOxjZ/ctCo96Pz8xwqCjJNVKIh4PtF4V4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)