UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UmnaEk5MrMZoUXwfzvmZ34DjilbVpd6yi4hEdmFc+a0='
WHERE
key_id = 'f8f0bb2024e72a53cfe4e6a4dca3e180900aa6dd44a01e4c01407e953c7f4e29'
AND (
token = 'UmnaEk5MrMZoUXwfzvmZ34DjilbVpd6yi4hEdmFc+a0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)