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