UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xu2WJ4tnedKhV36zHwKCpnFnM3HP0FChAiyK2UrBcr0='
WHERE
key_id = '49fe7f707143682e2f0aa59bd412398cb2fc5997d9d19371a21bc9f5853be018'
AND (
token = 'Xu2WJ4tnedKhV36zHwKCpnFnM3HP0FChAiyK2UrBcr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)