UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ICdhXzCwWtTG9h0j2u5qob58DqzKIU8Qw7NH6aHARiY='
WHERE
key_id = 'b5719ae27cb978f1f5867582ef971e1654a3d74cd6d9e61463e9b134b3222f57'
AND (
token = 'ICdhXzCwWtTG9h0j2u5qob58DqzKIU8Qw7NH6aHARiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)