UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HUFW7YCKo3JfphzdSuG+CBg7JhTvvR7da1++FDq+1LI='
WHERE
key_id = 'f564905f17ee50f6b35355c888b92313b1606e849a1081d744653c50657dd4e3'
AND (
token = 'HUFW7YCKo3JfphzdSuG+CBg7JhTvvR7da1++FDq+1LI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)