UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C5gIT9559QJ3Sg1sK64fdD3i+iltY7BIYC+jUuuWfIE='
WHERE
key_id = '7d3b05a8684fb0c5f5a25e00a18c20c8b60185cb9d540213d1cb3bf9f93cdfd3'
AND (
token = 'C5gIT9559QJ3Sg1sK64fdD3i+iltY7BIYC+jUuuWfIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)