UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nA7eEBqS8nCSNdnNMxIKmxcU0s6SynOzW23UNiVrfbg='
WHERE
key_id = '2ec41f681b4728b9a22bb05a84fb423fece81b83dea4a136b6b7a507b11a37c5'
AND (
token = 'nA7eEBqS8nCSNdnNMxIKmxcU0s6SynOzW23UNiVrfbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)