UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gxmNbxAn8LBc67z/NnM2eD7SdORHT26s2XiQVqqzTpE='
WHERE
key_id = 'f23e9725a3fb88ea4e422f7b5046f2e17f60289c27f584332f4cb06b08dd9a3d'
AND (
token = 'gxmNbxAn8LBc67z/NnM2eD7SdORHT26s2XiQVqqzTpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)