UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piKVB0edmE+UBrc9QQ/hOz7W06QPqcOPYeDCi0Ncqlw='
WHERE
key_id = 'df0da6676f251879daca4bc8110dbf56a0750aba50a8cb4d54493b994a69ae6d'
AND (
token = 'piKVB0edmE+UBrc9QQ/hOz7W06QPqcOPYeDCi0Ncqlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)