UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i5UU3YXcj3oWxsCRRDIvfdhnXW0j5rbZ6iWbvBy2s8E='
WHERE
key_id = '893aa355fe28ff7b9fc13a4809eff84037a6781d4f8f95003cf3c304651ad7fd'
AND (
token = 'i5UU3YXcj3oWxsCRRDIvfdhnXW0j5rbZ6iWbvBy2s8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)