UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COj5u30MKwSq/l6cxuJzVBM0ZcmfhqrTC0t28e/MLAU='
WHERE
key_id = 'd8e5c9bab07452865934fdcf81fe43c536352398536b262575b282583d451bbb'
AND (
token = 'COj5u30MKwSq/l6cxuJzVBM0ZcmfhqrTC0t28e/MLAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)