UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zS73L3F2fYn6YEN4TNOipz0j2V1fXU0B5am3asDJddY='
WHERE
key_id = '69307ea757aca1f07785faf68f5fe866d32925aafa5280037e3f571aa105045a'
AND (
token = 'zS73L3F2fYn6YEN4TNOipz0j2V1fXU0B5am3asDJddY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)