UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SgtxunUhRG9A1e2dKzK2I8EA8K3rVgiE00FAQND/mI8='
WHERE
key_id = 'd7bbe009cee692a642d54d34d461a3ea3ed1b80e9459e412841c4bd225d3133f'
AND (
token = 'SgtxunUhRG9A1e2dKzK2I8EA8K3rVgiE00FAQND/mI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)