UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KfNVI64sIEDfuZAl9hr5F7Un7yA8+1YG6qI+kPvMKto='
WHERE
key_id = 'df2a26b668f90f3b397a40849939c714be9183e11865c5a8485a361709de9ec0'
AND (
token = 'KfNVI64sIEDfuZAl9hr5F7Un7yA8+1YG6qI+kPvMKto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)