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