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