UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v8VCNXIO+Xe47C8112N6nS1GEiGsJgZk6YG/jdRq2MQ='
WHERE
key_id = '49c1f64e8487f78cf607825bacd9e9db27de2423f67e764c84d8aa832d823559'
AND (
token = 'v8VCNXIO+Xe47C8112N6nS1GEiGsJgZk6YG/jdRq2MQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)