UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGt0AfNHt3K8jfzl9nZ43mbNOLa/nncW06IWGUaJie8='
WHERE
key_id = 'd6c3384c2a9eb7dd5d35ca842a8cfe11166dc3e3d0fe7ad212129e75518fe1f2'
AND (
token = 'VGt0AfNHt3K8jfzl9nZ43mbNOLa/nncW06IWGUaJie8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)