UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'swJgqK6zlb6233EDHo+DtjW/0KiAPbX6lLcqt5aIDW4='
WHERE
key_id = '64f6f9aab13cc634409f00b983378af81507bf4e94f33d7d6fafd65c85ea4dbe'
AND (
token = 'swJgqK6zlb6233EDHo+DtjW/0KiAPbX6lLcqt5aIDW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)