UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kGheitxBR8oKdJc7oinndfCRfW83w1H3Bv3+Ipw1+T8='
WHERE
key_id = '2f8cd70ccca1ea8d11a54c4ca8ee0e6897fde3dd2dff9db0ea2904df0e814b2f'
AND (
token = 'kGheitxBR8oKdJc7oinndfCRfW83w1H3Bv3+Ipw1+T8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)