UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9gHEuxKcRGPJsATa7o0YnXysXRL6ARLQToGvMbEg1jQ='
WHERE
key_id = '1a1b8c69123df1e6711b235c2cb94888f718b568efedfefe4a7b2897d14bc147'
AND (
token = '9gHEuxKcRGPJsATa7o0YnXysXRL6ARLQToGvMbEg1jQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)