UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6sNw8i1KYaVcTKCRGwEwNZ/H0OS8KsaCTgjp1u7nwh0='
WHERE
key_id = '69dfc26a58890990bf9aeda0f3ee851525ac2fb2203812bd9efb471996275d4d'
AND (
token = '6sNw8i1KYaVcTKCRGwEwNZ/H0OS8KsaCTgjp1u7nwh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)