UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pDu7UVWpdmv21JHavhkGI4138U13SjTFGa/78d41O2I='
WHERE
key_id = '4b6822ac297ee4775e7308120aed2eda1eab1fd510de74e89eba75d8ef815de1'
AND (
token = 'pDu7UVWpdmv21JHavhkGI4138U13SjTFGa/78d41O2I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)