UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'blRTOSJbLtZeFhPeKd47maxkir0tSBJ4Cyu6pfi4E9s='
WHERE
key_id = '1180d8f28b951ba1ba731bebd025dcd6574837c2a8c55255fb63c529122f1bb1'
AND (
token = 'blRTOSJbLtZeFhPeKd47maxkir0tSBJ4Cyu6pfi4E9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)