UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tvf2CazdBmgn7RyKymOF8gw3swHdK5WS9i4P53Z/W5k='
WHERE
key_id = '5b5101092750635ac387b4108206f71a2a1259520826bfac6a202ad3bb1efa6a'
AND (
token = 'Tvf2CazdBmgn7RyKymOF8gw3swHdK5WS9i4P53Z/W5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)