UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QTeUDlflqhQ/eSPSg7/ItHss1rDD6hrcnEsbGo+nkw8='
WHERE
key_id = '7e075a8be0293268ca2330d8e7f223b4c29baf206e96b43eef05b6390b260fde'
AND (
token = 'QTeUDlflqhQ/eSPSg7/ItHss1rDD6hrcnEsbGo+nkw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)