UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K8Jq0E0UVSYRgZuDPqgV3zmaOtjyCMvAKlSNV6m5m68='
WHERE
key_id = 'e25bd6f16d148ae47761a02c259d43f393b65e9664cf357cd9f7e5723ab3497c'
AND (
token = 'K8Jq0E0UVSYRgZuDPqgV3zmaOtjyCMvAKlSNV6m5m68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)