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