UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmHoj38aJTbAAzsg1lsVAoe5SSCyq7RUi+mxJhyz4bY='
WHERE
key_id = '12f96db51cef969d3a608207780992ee31d5e90083847efa37e450a82907efc2'
AND (
token = 'CmHoj38aJTbAAzsg1lsVAoe5SSCyq7RUi+mxJhyz4bY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)