UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7unU1qzufL0GpPfpcAkGqNtqVOmahIA9FtRl+zgy9tk='
WHERE
key_id = '697f46180272da43c6cb77ebc582589ada99d400431f062317df2921c21b10dc'
AND (
token = '7unU1qzufL0GpPfpcAkGqNtqVOmahIA9FtRl+zgy9tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)