UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TqCWu/yVWO+o8pRabbQGGhT4Zpauo+k8AEWUmUdbTj8='
WHERE
key_id = 'e790705765a7e8b50af0ef768c6b0c16bd7f7563abac4a74a5d95895eb18fe7f'
AND (
token = 'TqCWu/yVWO+o8pRabbQGGhT4Zpauo+k8AEWUmUdbTj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)