UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4qYZMSrsk+7Ev5jDtxapn6OkIUUW+NvpNHd7TsVRHs='
WHERE
key_id = '94dc7383c5ba99a205fb6c2e5f8544ab7f53d6d21b2ab4825487aee09b1dc3b9'
AND (
token = 'X4qYZMSrsk+7Ev5jDtxapn6OkIUUW+NvpNHd7TsVRHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)